Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 138791 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 13.8 MiB |
| Average record size in memory | 104.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 12 |
Demanda is highly correlated with Month and 6 other fields | High correlation |
TMAX-CAB is highly correlated with Demanda and 6 other fields | High correlation |
TMAX-HMO is highly correlated with Demanda and 6 other fields | High correlation |
TMAX-OBR is highly correlated with Demanda and 6 other fields | High correlation |
TMIN-CAB is highly correlated with Demanda and 6 other fields | High correlation |
TMIN-HMO is highly correlated with Demanda and 6 other fields | High correlation |
TMIN-OBR is highly correlated with Demanda and 6 other fields | High correlation |
Month is highly correlated with Demanda and 6 other fields | High correlation |
Date has 19847 (14.3%) zeros | Zeros |
Hour has 5782 (4.2%) zeros | Zeros |
PREC_HMO (mm) has 120839 (87.1%) zeros | Zeros |
PREC_OBR (mm) has 122255 (88.1%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-07 03:45:01.774779 |
|---|---|
| Analysis finished | 2022-11-07 03:45:18.986628 |
| Duration | 17.21 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
FECHA
Date
| Distinct | 5783 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2007-01-01 00:00:00 |
|---|---|
| Maximum | 2022-10-31 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 45638 |
|---|---|
| Distinct (%) | 32.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2505.570239 |
| Minimum | 959 |
|---|---|
| Maximum | 5402.72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 959 |
|---|---|
| 5-th percentile | 1408 |
| Q1 | 1867 |
| median | 2343.74 |
| Q3 | 3054.1 |
| 95-th percentile | 4079 |
| Maximum | 5402.72 |
| Range | 4443.72 |
| Interquartile range (IQR) | 1187.1 |
Descriptive statistics
| Standard deviation | 823.7167817 |
|---|---|
| Coefficient of variation (CV) | 0.3287542168 |
| Kurtosis | -0.2876228818 |
| Mean | 2505.570239 |
| Median Absolute Deviation (MAD) | 559.74 |
| Skewness | 0.6406278244 |
| Sum | 347750599 |
| Variance | 678509.3364 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1600 | 82 | 0.1% |
| 1786 | 80 | 0.1% |
| 1515 | 78 | 0.1% |
| 1497 | 76 | 0.1% |
| 1574 | 72 | 0.1% |
| 1784 | 72 | 0.1% |
| 1537 | 72 | 0.1% |
| 1578 | 72 | 0.1% |
| 1812 | 71 | 0.1% |
| 1590 | 71 | 0.1% |
| Other values (45628) | 138045 |
| Value | Count | Frequency (%) |
| 959 | 1 | |
| 966 | 1 | |
| 980 | 1 | |
| 999 | 1 | |
| 1001 | 1 | |
| 1002 | 1 | |
| 1003 | 2 | |
| 1004 | 1 | |
| 1005 | 1 | |
| 1006 | 1 |
| Value | Count | Frequency (%) |
| 5402.72 | 1 | |
| 5399 | 1 | |
| 5390 | 1 | |
| 5348.84 | 1 | |
| 5336.53 | 1 | |
| 5297.23 | 1 | |
| 5295.02 | 1 | |
| 5290.24 | 1 | |
| 5289.39 | 1 | |
| 5286 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.99950285 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 19847 |
| Zeros (%) | 14.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.000214279 |
|---|---|
| Coefficient of variation (CV) | 0.6668486011 |
| Kurtosis | -1.250177853 |
| Mean | 2.99950285 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0001865299127 |
| Sum | 416304 |
| Variance | 4.000857163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0 | 19847 | |
| 1 | 19824 | |
| 2 | 19824 | |
| 3 | 19824 | |
| 4 | 19824 | |
| 5 | 19824 | |
| 6 | 19824 |
| Value | Count | Frequency (%) |
| 0 | 19847 | |
| 1 | 19824 | |
| 2 | 19824 | |
| 3 | 19824 | |
| 4 | 19824 | |
| 5 | 19824 | |
| 6 | 19824 |
| Value | Count | Frequency (%) |
| 6 | 19824 | |
| 5 | 19824 | |
| 4 | 19824 | |
| 3 | 19824 | |
| 2 | 19824 | |
| 1 | 19824 | |
| 0 | 19847 |
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.50008286 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 5782 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 12 |
| Q3 | 17.5 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.922167599 |
|---|---|
| Coefficient of variation (CV) | 0.6019232804 |
| Kurtosis | -1.204170464 |
| Mean | 11.50008286 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -2.872424259 × 10-6 |
| Sum | 1596108 |
| Variance | 47.91640427 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 1 | 5783 | 4.2% |
| 2 | 5783 | 4.2% |
| 23 | 5783 | 4.2% |
| 22 | 5783 | 4.2% |
| 21 | 5783 | 4.2% |
| 20 | 5783 | 4.2% |
| 19 | 5783 | 4.2% |
| 18 | 5783 | 4.2% |
| 17 | 5783 | 4.2% |
| 16 | 5783 | 4.2% |
| Other values (14) | 80961 |
| Value | Count | Frequency (%) |
| 0 | 5782 | |
| 1 | 5783 | |
| 2 | 5783 | |
| 3 | 5783 | |
| 4 | 5783 | |
| 5 | 5783 | |
| 6 | 5783 | |
| 7 | 5783 | |
| 8 | 5783 | |
| 9 | 5783 |
| Value | Count | Frequency (%) |
| 23 | 5783 | |
| 22 | 5783 | |
| 21 | 5783 | |
| 20 | 5783 | |
| 19 | 5783 | |
| 18 | 5783 | |
| 17 | 5783 | |
| 16 | 5783 | |
| 15 | 5783 | |
| 14 | 5783 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.470383526 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.428032772 |
|---|---|
| Coefficient of variation (CV) | 0.5298036443 |
| Kurtosis | -1.196339534 |
| Mean | 6.470383526 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.003035689015 |
| Sum | 898031 |
| Variance | 11.75140869 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 3 | 11904 | |
| 5 | 11904 | |
| 7 | 11904 | |
| 8 | 11904 | |
| 10 | 11904 | |
| 1 | 11903 | |
| 4 | 11520 | |
| 6 | 11520 | |
| 9 | 11520 | |
| 12 | 11160 | |
| Other values (2) | 21648 |
| Value | Count | Frequency (%) |
| 1 | 11903 | |
| 2 | 10848 | |
| 3 | 11904 | |
| 4 | 11520 | |
| 5 | 11904 | |
| 6 | 11520 | |
| 7 | 11904 | |
| 8 | 11904 | |
| 9 | 11520 | |
| 10 | 11904 |
| Value | Count | Frequency (%) |
| 12 | 11160 | |
| 11 | 10800 | |
| 10 | 11904 | |
| 9 | 11520 | |
| 8 | 11904 | |
| 7 | 11904 | |
| 6 | 11520 | |
| 5 | 11904 | |
| 4 | 11520 | |
| 3 | 11904 |
| Distinct | 2134 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.99878551 |
| Minimum | 9.09 |
|---|---|
| Maximum | 49.61 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 9.09 |
|---|---|
| 5-th percentile | 19.8 |
| Q1 | 26.96 |
| median | 33.73 |
| Q3 | 39.5 |
| 95-th percentile | 44.06 |
| Maximum | 49.61 |
| Range | 40.52 |
| Interquartile range (IQR) | 12.54 |
Descriptive statistics
| Standard deviation | 7.801089285 |
|---|---|
| Coefficient of variation (CV) | 0.2364053454 |
| Kurtosis | -0.8615582407 |
| Mean | 32.99878551 |
| Median Absolute Deviation (MAD) | 6.27 |
| Skewness | -0.2962016899 |
| Sum | 4579934.44 |
| Variance | 60.85699404 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40 | 1392 | 1.0% |
| 38 | 1248 | 0.9% |
| 41 | 1200 | 0.9% |
| 26 | 1128 | 0.8% |
| 39 | 1128 | 0.8% |
| 36 | 1104 | 0.8% |
| 23 | 1080 | 0.8% |
| 31 | 1056 | 0.8% |
| 25 | 1056 | 0.8% |
| 37 | 1008 | 0.7% |
| Other values (2124) | 127391 |
| Value | Count | Frequency (%) |
| 9.09 | 24 | < 0.1% |
| 11 | 24 | < 0.1% |
| 12 | 72 | |
| 12.09 | 24 | < 0.1% |
| 12.23 | 24 | < 0.1% |
| 12.3 | 24 | < 0.1% |
| 12.5 | 24 | < 0.1% |
| 12.81 | 24 | < 0.1% |
| 13 | 72 | |
| 13.1 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 49.61 | 24 | |
| 49.53 | 24 | |
| 48.4 | 24 | |
| 48.1 | 24 | |
| 48 | 24 | |
| 47.87 | 24 | |
| 47.71 | 24 | |
| 47.69 | 24 | |
| 47.6 | 24 | |
| 47.53 | 24 |
| Distinct | 1328 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.55376026 |
| Minimum | 8 |
|---|---|
| Maximum | 49.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 21.77 |
| Q1 | 28.71 |
| median | 34.5 |
| Q3 | 39 |
| 95-th percentile | 43 |
| Maximum | 49.1 |
| Range | 41.1 |
| Interquartile range (IQR) | 10.29 |
Descriptive statistics
| Standard deviation | 6.634450905 |
|---|---|
| Coefficient of variation (CV) | 0.1977260031 |
| Kurtosis | -0.6405264241 |
| Mean | 33.55376026 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.3834708529 |
| Sum | 4656959.94 |
| Variance | 44.01593881 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 37 | 3888 | 2.8% |
| 39 | 3408 | 2.5% |
| 38 | 3336 | 2.4% |
| 35 | 3336 | 2.4% |
| 40 | 3192 | 2.3% |
| 41 | 3144 | 2.3% |
| 36 | 2760 | 2.0% |
| 42 | 2760 | 2.0% |
| 34 | 2664 | 1.9% |
| 30 | 2568 | 1.9% |
| Other values (1318) | 107735 |
| Value | Count | Frequency (%) |
| 8 | 24 | < 0.1% |
| 14.58 | 24 | < 0.1% |
| 14.8 | 24 | < 0.1% |
| 15.5 | 48 | < 0.1% |
| 15.7 | 24 | < 0.1% |
| 15.71 | 24 | < 0.1% |
| 16 | 96 | |
| 16.01 | 24 | < 0.1% |
| 16.4 | 48 | < 0.1% |
| 16.5 | 144 |
| Value | Count | Frequency (%) |
| 49.1 | 24 | < 0.1% |
| 48.86 | 24 | < 0.1% |
| 48 | 24 | < 0.1% |
| 47.58 | 24 | < 0.1% |
| 47.5 | 72 | |
| 47 | 96 | |
| 46.86 | 24 | < 0.1% |
| 46.5 | 120 | |
| 46.23 | 24 | < 0.1% |
| 46.2 | 24 | < 0.1% |
| Distinct | 1243 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.53774279 |
| Minimum | 12 |
|---|---|
| Maximum | 47 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 30 |
| median | 35.41 |
| Q3 | 39.28 |
| 95-th percentile | 43 |
| Maximum | 47 |
| Range | 35 |
| Interquartile range (IQR) | 9.28 |
Descriptive statistics
| Standard deviation | 5.927637647 |
|---|---|
| Coefficient of variation (CV) | 0.1716278242 |
| Kurtosis | -0.649182679 |
| Mean | 34.53774279 |
| Median Absolute Deviation (MAD) | 4.59 |
| Skewness | -0.4153157434 |
| Sum | 4793527.86 |
| Variance | 35.13688808 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40 | 5856 | 4.2% |
| 38 | 5568 | 4.0% |
| 39 | 5424 | 3.9% |
| 41 | 4992 | 3.6% |
| 37 | 4704 | 3.4% |
| 36 | 4320 | 3.1% |
| 42 | 3792 | 2.7% |
| 29 | 3744 | 2.7% |
| 34 | 3648 | 2.6% |
| 33 | 3600 | 2.6% |
| Other values (1233) | 93143 |
| Value | Count | Frequency (%) |
| 12 | 24 | < 0.1% |
| 15 | 24 | < 0.1% |
| 16 | 48 | < 0.1% |
| 17 | 96 | |
| 17.7 | 24 | < 0.1% |
| 18 | 96 | |
| 18.5 | 24 | < 0.1% |
| 18.83 | 24 | < 0.1% |
| 19 | 168 | |
| 19.2 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 47 | 48 | < 0.1% |
| 46.5 | 24 | < 0.1% |
| 46.15 | 24 | < 0.1% |
| 46 | 168 | |
| 45.97 | 24 | < 0.1% |
| 45.85 | 24 | < 0.1% |
| 45.7 | 24 | < 0.1% |
| 45.68 | 24 | < 0.1% |
| 45.5 | 48 | < 0.1% |
| 45.45 | 24 | < 0.1% |
| Distinct | 2169 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.49558574 |
| Minimum | -6.8 |
|---|---|
| Maximum | 32.9 |
| Zeros | 192 |
| Zeros (%) | 0.1% |
| Negative | 720 |
| Negative (%) | 0.5% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -6.8 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 10.1 |
| median | 16 |
| Q3 | 23.57 |
| 95-th percentile | 28.78 |
| Maximum | 32.9 |
| Range | 39.7 |
| Interquartile range (IQR) | 13.47 |
Descriptive statistics
| Standard deviation | 7.921575778 |
|---|---|
| Coefficient of variation (CV) | 0.4802239766 |
| Kurtosis | -1.016973919 |
| Mean | 16.49558574 |
| Median Absolute Deviation (MAD) | 6.64 |
| Skewness | -0.0117286117 |
| Sum | 2289438.84 |
| Variance | 62.75136281 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22 | 1440 | 1.0% |
| 12 | 1440 | 1.0% |
| 24 | 1368 | 1.0% |
| 10 | 1248 | 0.9% |
| 8 | 1224 | 0.9% |
| 14 | 1200 | 0.9% |
| 9 | 1176 | 0.8% |
| 15 | 1151 | 0.8% |
| 23 | 1104 | 0.8% |
| 26 | 1080 | 0.8% |
| Other values (2159) | 126360 |
| Value | Count | Frequency (%) |
| -6.8 | 24 | |
| -5.8 | 24 | |
| -5.4 | 24 | |
| -5 | 24 | |
| -3.2 | 24 | |
| -3 | 48 | |
| -2.92 | 24 | |
| -2.2 | 24 | |
| -2.13 | 24 | |
| -2 | 48 |
| Value | Count | Frequency (%) |
| 32.9 | 24 | |
| 32.86 | 24 | |
| 32.5 | 24 | |
| 32.48 | 24 | |
| 32.36 | 24 | |
| 32.21 | 24 | |
| 32.06 | 24 | |
| 32.02 | 24 | |
| 32.01 | 24 | |
| 31.78 | 24 |
| Distinct | 1338 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.50379463 |
| Minimum | -3 |
|---|---|
| Maximum | 34 |
| Zeros | 24 |
| Zeros (%) | < 0.1% |
| Negative | 24 |
| Negative (%) | < 0.1% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -3 |
|---|---|
| 5-th percentile | 7.09 |
| Q1 | 13 |
| median | 18 |
| Q3 | 25 |
| 95-th percentile | 29 |
| Maximum | 34 |
| Range | 37 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.05737714 |
|---|---|
| Coefficient of variation (CV) | 0.3814016143 |
| Kurtosis | -1.049131135 |
| Mean | 18.50379463 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.1101890143 |
| Sum | 2568160.16 |
| Variance | 49.8065721 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 27 | 4344 | 3.1% |
| 26 | 3624 | 2.6% |
| 25 | 3600 | 2.6% |
| 11 | 3240 | 2.3% |
| 16 | 3239 | 2.3% |
| 28 | 3120 | 2.2% |
| 13 | 3000 | 2.2% |
| 14 | 2952 | 2.1% |
| 22 | 2880 | 2.1% |
| 12 | 2784 | 2.0% |
| Other values (1328) | 106008 |
| Value | Count | Frequency (%) |
| -3 | 24 | |
| 0 | 24 | |
| 0.37 | 24 | |
| 0.46 | 24 | |
| 0.62 | 24 | |
| 0.66 | 24 | |
| 0.68 | 24 | |
| 0.7 | 24 | |
| 1.06 | 24 | |
| 1.23 | 24 |
| Value | Count | Frequency (%) |
| 34 | 24 | < 0.1% |
| 33.4 | 24 | < 0.1% |
| 33.3 | 24 | < 0.1% |
| 32 | 168 | 0.1% |
| 31.8 | 24 | < 0.1% |
| 31.73 | 24 | < 0.1% |
| 31.5 | 48 | < 0.1% |
| 31.39 | 24 | < 0.1% |
| 31.07 | 24 | < 0.1% |
| 31 | 720 |
| Distinct | 1304 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.66678272 |
| Minimum | 2 |
|---|---|
| Maximum | 42.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8.22 |
| Q1 | 13 |
| median | 18 |
| Q3 | 25 |
| 95-th percentile | 29 |
| Maximum | 42.5 |
| Range | 40.5 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.737229591 |
|---|---|
| Coefficient of variation (CV) | 0.36092077 |
| Kurtosis | -1.139080852 |
| Mean | 18.66678272 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.02303209835 |
| Sum | 2590781.44 |
| Variance | 45.39026256 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26 | 5328 | 3.8% |
| 25 | 4776 | 3.4% |
| 14 | 4559 | 3.3% |
| 27 | 4464 | 3.2% |
| 24 | 4440 | 3.2% |
| 10 | 4128 | 3.0% |
| 13 | 3984 | 2.9% |
| 16 | 3936 | 2.8% |
| 15 | 3864 | 2.8% |
| 11 | 3792 | 2.7% |
| Other values (1294) | 95520 |
| Value | Count | Frequency (%) |
| 2 | 48 | |
| 2.6 | 24 | |
| 3 | 24 | |
| 3.3 | 24 | |
| 3.88 | 24 | |
| 4 | 48 | |
| 4.04 | 24 | |
| 4.1 | 24 | |
| 4.34 | 24 | |
| 4.48 | 24 |
| Value | Count | Frequency (%) |
| 42.5 | 24 | < 0.1% |
| 33 | 24 | < 0.1% |
| 32 | 144 | |
| 31.96 | 24 | < 0.1% |
| 31.92 | 24 | < 0.1% |
| 31.67 | 24 | < 0.1% |
| 31.62 | 24 | < 0.1% |
| 31.56 | 24 | < 0.1% |
| 31.51 | 24 | < 0.1% |
| 31.41 | 24 | < 0.1% |
| Distinct | 252 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.398324099 |
| Minimum | 0 |
|---|---|
| Maximum | 117 |
| Zeros | 120839 |
| Zeros (%) | 87.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7.2 |
| Maximum | 117 |
| Range | 117 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.939963432 |
|---|---|
| Coefficient of variation (CV) | 4.963057876 |
| Kurtosis | 76.87536046 |
| Mean | 1.398324099 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.721436168 |
| Sum | 194074.8 |
| Variance | 48.16309244 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 120839 | |
| 0.01 | 3312 | 2.4% |
| 1 | 480 | 0.3% |
| 0.3 | 384 | 0.3% |
| 1.2 | 360 | 0.3% |
| 0.5 | 336 | 0.2% |
| 0.1 | 312 | 0.2% |
| 2 | 288 | 0.2% |
| 0.2 | 288 | 0.2% |
| 3 | 264 | 0.2% |
| Other values (242) | 11928 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 120839 | |
| 0.01 | 3312 | 2.4% |
| 0.04 | 24 | < 0.1% |
| 0.1 | 312 | 0.2% |
| 0.2 | 288 | 0.2% |
| 0.3 | 384 | 0.3% |
| 0.4 | 192 | 0.1% |
| 0.5 | 336 | 0.2% |
| 0.6 | 96 | 0.1% |
| 0.7 | 144 | 0.1% |
| Value | Count | Frequency (%) |
| 117 | 24 | |
| 115 | 24 | |
| 103.9 | 24 | |
| 92.1 | 24 | |
| 83.5 | 24 | |
| 80.5 | 24 | |
| 80 | 24 | |
| 72.5 | 24 | |
| 72 | 24 | |
| 71.8 | 24 |
| Distinct | 184 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.166726373 |
| Minimum | 0 |
|---|---|
| Maximum | 166.8 |
| Zeros | 122255 |
| Zeros (%) | 88.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.5 |
| Maximum | 166.8 |
| Range | 166.8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.680982958 |
|---|---|
| Coefficient of variation (CV) | 5.726263771 |
| Kurtosis | 141.1251942 |
| Mean | 1.166726373 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.03783287 |
| Sum | 161931.12 |
| Variance | 44.63553329 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 122255 | |
| 0.01 | 2856 | 2.1% |
| 1 | 1440 | 1.0% |
| 0.5 | 936 | 0.7% |
| 2 | 720 | 0.5% |
| 1.5 | 552 | 0.4% |
| 3 | 480 | 0.3% |
| 2.5 | 384 | 0.3% |
| 5 | 336 | 0.2% |
| 9 | 264 | 0.2% |
| Other values (174) | 8568 | 6.2% |
| Value | Count | Frequency (%) |
| 0 | 122255 | |
| 0.01 | 2856 | 2.1% |
| 0.05 | 24 | < 0.1% |
| 0.1 | 144 | 0.1% |
| 0.2 | 216 | 0.2% |
| 0.3 | 240 | 0.2% |
| 0.4 | 24 | < 0.1% |
| 0.5 | 936 | 0.7% |
| 0.6 | 96 | 0.1% |
| 0.7 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 166.8 | 24 | |
| 104 | 24 | |
| 102 | 24 | |
| 101 | 24 | |
| 91.7 | 24 | |
| 91 | 24 | |
| 85 | 24 | |
| 81 | 24 | |
| 80.6 | 24 | |
| 74 | 24 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| FECHA | Demanda | Date | Hour | Month | TMAX-CAB | TMAX-HMO | TMAX-OBR | TMIN-CAB | TMIN-HMO | TMIN-OBR | PREC_HMO (mm) | PREC_OBR (mm) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2007-01-01 | 1297.0 | 0 | 1 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 1 | 2007-01-01 | 1255.0 | 0 | 2 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 2 | 2007-01-01 | 1222.0 | 0 | 3 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 3 | 2007-01-01 | 1168.0 | 0 | 4 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 4 | 2007-01-01 | 1128.0 | 0 | 5 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 5 | 2007-01-01 | 1100.0 | 0 | 6 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 6 | 2007-01-01 | 1083.0 | 0 | 7 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 7 | 2007-01-01 | 1076.0 | 0 | 8 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 8 | 2007-01-01 | 1022.0 | 0 | 9 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
| 9 | 2007-01-01 | 1029.0 | 0 | 10 | 1 | 21.0 | 21.5 | 25.0 | 2.0 | 9.0 | 7.5 | 0.0 | 0.0 |
Last rows
| FECHA | Demanda | Date | Hour | Month | TMAX-CAB | TMAX-HMO | TMAX-OBR | TMIN-CAB | TMIN-HMO | TMIN-OBR | PREC_HMO (mm) | PREC_OBR (mm) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138781 | 2022-10-31 | 2834.87 | 0 | 14 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138782 | 2022-10-31 | 2914.07 | 0 | 15 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138783 | 2022-10-31 | 2990.75 | 0 | 16 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138784 | 2022-10-31 | 3038.08 | 0 | 17 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138785 | 2022-10-31 | 3014.08 | 0 | 18 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138786 | 2022-10-31 | 2934.74 | 0 | 19 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138787 | 2022-10-31 | 2926.85 | 0 | 20 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138788 | 2022-10-31 | 2894.38 | 0 | 21 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138789 | 2022-10-31 | 2877.56 | 0 | 22 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |
| 138790 | 2022-10-31 | 2843.08 | 0 | 23 | 10 | 29.0 | 31.5 | 31.5 | 15.0 | 16.0 | 14.0 | 0.0 | 0.0 |